# -*- coding: utf-8 -*-
from db.mysql import MysqlClient
from common.helper import Helper
from itertools import product

name = "全年驾乘意外险"
mysql = MysqlClient()

plan = {
    "planA": {
        "days": "1y",
        "people_count": "1",
        "accident_death": "150000",
        "accident_medical": "15000",
        "totalMoney":"330000",
        "price": "100.00"
    },
    "planB":{
        "days": "1y",
        "people_count": "1",
        "accident_death": "250000",
        "accident_medical": "25000",
        "accident_hospital":"4500",
        "totalMoney":"559000",
        "price": "150.00"
    },
    "planC":{
        "days": "1y",
        "people_count": "1",
        "accident_death": "300000",
        "accident_medical": "30000",
        "totalMoney":"660000",
        "price": "200.00"

    }

}
for k in plan:
    data = plan[k]
    data["name"] = name
    data["company"] = "锦泰保险"
    Helper.mergeTable( name,mysql,data )